package me.mayt.wxfl.dao.mapper.bo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("ORDER_ID like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("ORDER_ID not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdIsNull() {
            addCriterion("PARENT_ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdIsNotNull() {
            addCriterion("PARENT_ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdEqualTo(String value) {
            addCriterion("PARENT_ORDER_ID =", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdNotEqualTo(String value) {
            addCriterion("PARENT_ORDER_ID <>", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdGreaterThan(String value) {
            addCriterion("PARENT_ORDER_ID >", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("PARENT_ORDER_ID >=", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdLessThan(String value) {
            addCriterion("PARENT_ORDER_ID <", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdLessThanOrEqualTo(String value) {
            addCriterion("PARENT_ORDER_ID <=", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdLike(String value) {
            addCriterion("PARENT_ORDER_ID like", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdNotLike(String value) {
            addCriterion("PARENT_ORDER_ID not like", value, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdIn(List<String> values) {
            addCriterion("PARENT_ORDER_ID in", values, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdNotIn(List<String> values) {
            addCriterion("PARENT_ORDER_ID not in", values, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdBetween(String value1, String value2) {
            addCriterion("PARENT_ORDER_ID between", value1, value2, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andParentOrderIdNotBetween(String value1, String value2) {
            addCriterion("PARENT_ORDER_ID not between", value1, value2, "parentOrderId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("USER_ID =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("USER_ID <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("USER_ID >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("USER_ID >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("USER_ID <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("USER_ID <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("USER_ID like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("USER_ID not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("USER_ID in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("USER_ID not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("USER_ID between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("USER_ID not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNull() {
            addCriterion("ORDER_STATE is null");
            return (Criteria) this;
        }

        public Criteria andOrderStateIsNotNull() {
            addCriterion("ORDER_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStateEqualTo(String value) {
            addCriterion("ORDER_STATE =", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotEqualTo(String value) {
            addCriterion("ORDER_STATE <>", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThan(String value) {
            addCriterion("ORDER_STATE >", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_STATE >=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThan(String value) {
            addCriterion("ORDER_STATE <", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLessThanOrEqualTo(String value) {
            addCriterion("ORDER_STATE <=", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateLike(String value) {
            addCriterion("ORDER_STATE like", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotLike(String value) {
            addCriterion("ORDER_STATE not like", value, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateIn(List<String> values) {
            addCriterion("ORDER_STATE in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotIn(List<String> values) {
            addCriterion("ORDER_STATE not in", values, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateBetween(String value1, String value2) {
            addCriterion("ORDER_STATE between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andOrderStateNotBetween(String value1, String value2) {
            addCriterion("ORDER_STATE not between", value1, value2, "orderState");
            return (Criteria) this;
        }

        public Criteria andProductIsNull() {
            addCriterion("PRODUCT is null");
            return (Criteria) this;
        }

        public Criteria andProductIsNotNull() {
            addCriterion("PRODUCT is not null");
            return (Criteria) this;
        }

        public Criteria andProductEqualTo(String value) {
            addCriterion("PRODUCT =", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductNotEqualTo(String value) {
            addCriterion("PRODUCT <>", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductGreaterThan(String value) {
            addCriterion("PRODUCT >", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCT >=", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductLessThan(String value) {
            addCriterion("PRODUCT <", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductLessThanOrEqualTo(String value) {
            addCriterion("PRODUCT <=", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductLike(String value) {
            addCriterion("PRODUCT like", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductNotLike(String value) {
            addCriterion("PRODUCT not like", value, "product");
            return (Criteria) this;
        }

        public Criteria andProductIn(List<String> values) {
            addCriterion("PRODUCT in", values, "product");
            return (Criteria) this;
        }

        public Criteria andProductNotIn(List<String> values) {
            addCriterion("PRODUCT not in", values, "product");
            return (Criteria) this;
        }

        public Criteria andProductBetween(String value1, String value2) {
            addCriterion("PRODUCT between", value1, value2, "product");
            return (Criteria) this;
        }

        public Criteria andProductNotBetween(String value1, String value2) {
            addCriterion("PRODUCT not between", value1, value2, "product");
            return (Criteria) this;
        }

        public Criteria andPayFeeIsNull() {
            addCriterion("PAY_FEE is null");
            return (Criteria) this;
        }

        public Criteria andPayFeeIsNotNull() {
            addCriterion("PAY_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andPayFeeEqualTo(Long value) {
            addCriterion("PAY_FEE =", value, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeNotEqualTo(Long value) {
            addCriterion("PAY_FEE <>", value, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeGreaterThan(Long value) {
            addCriterion("PAY_FEE >", value, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeGreaterThanOrEqualTo(Long value) {
            addCriterion("PAY_FEE >=", value, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeLessThan(Long value) {
            addCriterion("PAY_FEE <", value, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeLessThanOrEqualTo(Long value) {
            addCriterion("PAY_FEE <=", value, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeIn(List<Long> values) {
            addCriterion("PAY_FEE in", values, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeNotIn(List<Long> values) {
            addCriterion("PAY_FEE not in", values, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeBetween(Long value1, Long value2) {
            addCriterion("PAY_FEE between", value1, value2, "payFee");
            return (Criteria) this;
        }

        public Criteria andPayFeeNotBetween(Long value1, Long value2) {
            addCriterion("PAY_FEE not between", value1, value2, "payFee");
            return (Criteria) this;
        }

        public Criteria andCommissionRateIsNull() {
            addCriterion("COMMISSION_RATE is null");
            return (Criteria) this;
        }

        public Criteria andCommissionRateIsNotNull() {
            addCriterion("COMMISSION_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionRateEqualTo(String value) {
            addCriterion("COMMISSION_RATE =", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotEqualTo(String value) {
            addCriterion("COMMISSION_RATE <>", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateGreaterThan(String value) {
            addCriterion("COMMISSION_RATE >", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateGreaterThanOrEqualTo(String value) {
            addCriterion("COMMISSION_RATE >=", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateLessThan(String value) {
            addCriterion("COMMISSION_RATE <", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateLessThanOrEqualTo(String value) {
            addCriterion("COMMISSION_RATE <=", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateLike(String value) {
            addCriterion("COMMISSION_RATE like", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotLike(String value) {
            addCriterion("COMMISSION_RATE not like", value, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateIn(List<String> values) {
            addCriterion("COMMISSION_RATE in", values, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotIn(List<String> values) {
            addCriterion("COMMISSION_RATE not in", values, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateBetween(String value1, String value2) {
            addCriterion("COMMISSION_RATE between", value1, value2, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andCommissionRateNotBetween(String value1, String value2) {
            addCriterion("COMMISSION_RATE not between", value1, value2, "commissionRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateIsNull() {
            addCriterion("SUB_SIDE_RATE is null");
            return (Criteria) this;
        }

        public Criteria andSubSideRateIsNotNull() {
            addCriterion("SUB_SIDE_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andSubSideRateEqualTo(String value) {
            addCriterion("SUB_SIDE_RATE =", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateNotEqualTo(String value) {
            addCriterion("SUB_SIDE_RATE <>", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateGreaterThan(String value) {
            addCriterion("SUB_SIDE_RATE >", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_SIDE_RATE >=", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateLessThan(String value) {
            addCriterion("SUB_SIDE_RATE <", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateLessThanOrEqualTo(String value) {
            addCriterion("SUB_SIDE_RATE <=", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateLike(String value) {
            addCriterion("SUB_SIDE_RATE like", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateNotLike(String value) {
            addCriterion("SUB_SIDE_RATE not like", value, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateIn(List<String> values) {
            addCriterion("SUB_SIDE_RATE in", values, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateNotIn(List<String> values) {
            addCriterion("SUB_SIDE_RATE not in", values, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateBetween(String value1, String value2) {
            addCriterion("SUB_SIDE_RATE between", value1, value2, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andSubSideRateNotBetween(String value1, String value2) {
            addCriterion("SUB_SIDE_RATE not between", value1, value2, "subSideRate");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeIsNull() {
            addCriterion("ESTIMATE_FEE is null");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeIsNotNull() {
            addCriterion("ESTIMATE_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeEqualTo(Long value) {
            addCriterion("ESTIMATE_FEE =", value, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeNotEqualTo(Long value) {
            addCriterion("ESTIMATE_FEE <>", value, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeGreaterThan(Long value) {
            addCriterion("ESTIMATE_FEE >", value, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeGreaterThanOrEqualTo(Long value) {
            addCriterion("ESTIMATE_FEE >=", value, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeLessThan(Long value) {
            addCriterion("ESTIMATE_FEE <", value, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeLessThanOrEqualTo(Long value) {
            addCriterion("ESTIMATE_FEE <=", value, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeIn(List<Long> values) {
            addCriterion("ESTIMATE_FEE in", values, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeNotIn(List<Long> values) {
            addCriterion("ESTIMATE_FEE not in", values, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeBetween(Long value1, Long value2) {
            addCriterion("ESTIMATE_FEE between", value1, value2, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andEstimateFeeNotBetween(Long value1, Long value2) {
            addCriterion("ESTIMATE_FEE not between", value1, value2, "estimateFee");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceIsNull() {
            addCriterion("ACTUAL_COS_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceIsNotNull() {
            addCriterion("ACTUAL_COS_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceEqualTo(Long value) {
            addCriterion("ACTUAL_COS_PRICE =", value, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceNotEqualTo(Long value) {
            addCriterion("ACTUAL_COS_PRICE <>", value, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceGreaterThan(Long value) {
            addCriterion("ACTUAL_COS_PRICE >", value, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceGreaterThanOrEqualTo(Long value) {
            addCriterion("ACTUAL_COS_PRICE >=", value, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceLessThan(Long value) {
            addCriterion("ACTUAL_COS_PRICE <", value, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceLessThanOrEqualTo(Long value) {
            addCriterion("ACTUAL_COS_PRICE <=", value, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceIn(List<Long> values) {
            addCriterion("ACTUAL_COS_PRICE in", values, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceNotIn(List<Long> values) {
            addCriterion("ACTUAL_COS_PRICE not in", values, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceBetween(Long value1, Long value2) {
            addCriterion("ACTUAL_COS_PRICE between", value1, value2, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCosPriceNotBetween(Long value1, Long value2) {
            addCriterion("ACTUAL_COS_PRICE not between", value1, value2, "actualCosPrice");
            return (Criteria) this;
        }

        public Criteria andActualCommissionIsNull() {
            addCriterion("ACTUAL_COMMISSION is null");
            return (Criteria) this;
        }

        public Criteria andActualCommissionIsNotNull() {
            addCriterion("ACTUAL_COMMISSION is not null");
            return (Criteria) this;
        }

        public Criteria andActualCommissionEqualTo(Long value) {
            addCriterion("ACTUAL_COMMISSION =", value, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionNotEqualTo(Long value) {
            addCriterion("ACTUAL_COMMISSION <>", value, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionGreaterThan(Long value) {
            addCriterion("ACTUAL_COMMISSION >", value, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("ACTUAL_COMMISSION >=", value, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionLessThan(Long value) {
            addCriterion("ACTUAL_COMMISSION <", value, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionLessThanOrEqualTo(Long value) {
            addCriterion("ACTUAL_COMMISSION <=", value, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionIn(List<Long> values) {
            addCriterion("ACTUAL_COMMISSION in", values, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionNotIn(List<Long> values) {
            addCriterion("ACTUAL_COMMISSION not in", values, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionBetween(Long value1, Long value2) {
            addCriterion("ACTUAL_COMMISSION between", value1, value2, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andActualCommissionNotBetween(Long value1, Long value2) {
            addCriterion("ACTUAL_COMMISSION not between", value1, value2, "actualCommission");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNull() {
            addCriterion("ORDER_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNotNull() {
            addCriterion("ORDER_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualTo(Date value) {
            addCriterion("ORDER_TIME =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualTo(Date value) {
            addCriterion("ORDER_TIME <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThan(Date value) {
            addCriterion("ORDER_TIME >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ORDER_TIME >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThan(Date value) {
            addCriterion("ORDER_TIME <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualTo(Date value) {
            addCriterion("ORDER_TIME <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIn(List<Date> values) {
            addCriterion("ORDER_TIME in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotIn(List<Date> values) {
            addCriterion("ORDER_TIME not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeBetween(Date value1, Date value2) {
            addCriterion("ORDER_TIME between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotBetween(Date value1, Date value2) {
            addCriterion("ORDER_TIME not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("FINISH_TIME is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("FINISH_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(Date value) {
            addCriterion("FINISH_TIME =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(Date value) {
            addCriterion("FINISH_TIME <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(Date value) {
            addCriterion("FINISH_TIME >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("FINISH_TIME >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(Date value) {
            addCriterion("FINISH_TIME <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(Date value) {
            addCriterion("FINISH_TIME <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<Date> values) {
            addCriterion("FINISH_TIME in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<Date> values) {
            addCriterion("FINISH_TIME not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(Date value1, Date value2) {
            addCriterion("FINISH_TIME between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(Date value1, Date value2) {
            addCriterion("FINISH_TIME not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeIsNull() {
            addCriterion("SCOUT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andScoutTimeIsNotNull() {
            addCriterion("SCOUT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andScoutTimeEqualTo(Date value) {
            addCriterion("SCOUT_TIME =", value, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeNotEqualTo(Date value) {
            addCriterion("SCOUT_TIME <>", value, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeGreaterThan(Date value) {
            addCriterion("SCOUT_TIME >", value, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("SCOUT_TIME >=", value, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeLessThan(Date value) {
            addCriterion("SCOUT_TIME <", value, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeLessThanOrEqualTo(Date value) {
            addCriterion("SCOUT_TIME <=", value, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeIn(List<Date> values) {
            addCriterion("SCOUT_TIME in", values, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeNotIn(List<Date> values) {
            addCriterion("SCOUT_TIME not in", values, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeBetween(Date value1, Date value2) {
            addCriterion("SCOUT_TIME between", value1, value2, "scoutTime");
            return (Criteria) this;
        }

        public Criteria andScoutTimeNotBetween(Date value1, Date value2) {
            addCriterion("SCOUT_TIME not between", value1, value2, "scoutTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}